IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tr_ProjectFile_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tr_ProjectFile_Get]
GO

CREATE PROCEDURE [dbo].[tr_ProjectFile_Get]
	@FileId UNIQUEIDENTIFIER
AS

SELECT
	tr_File.MimeType,
	tr_File.FileName,
	tr_File.FileData
FROM 
	tr_File
WHERE 
	FileId = @FileId